﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$AccountsDBConnection$" formatter="bizobjlist of eComPaymentTerm">
	<FormatterInfo eComPaymentTermTypeField="bizObjTypeName" />
	<Sql>
		SELECT        
			ep.id, bizObjType AS bizObjTypeName, mustPayAtCheckOut, externalProcessing
		FROM
			eComCustomerPaymentTerms AS cp
		INNER JOIN eComPaymentTerms AS ep ON cp.paymentID = ep.id
		where 
			customerId=@userId;
	</Sql>
	<Param name="userId" type="UniqueIdentifier"/>
</AdoNetDataAccess>
